A join in which records from two tables are combined and added to the Recordset object only when there are equal values in the joined fields. Also referred to as an inner-join.